Automations

Database Commands

  • Version: 2.0.0
  • Official Verified

OpenBots command for connecting to and executing queries against a database. Supports OLE DB.

OpenBots.Commands.Database \ Execute Transaction Query Command

Command: Execute Transaction Query Command

This command performs an OleDb database query within the context of a transaction.

Parameters

Transaction Instance Name

Enter the unique instance that was specified in the **Create Database Transaction** command.

Required

Query

Define the OleDb query to execute.

Required

Query Parameters (Optional)

Define the query parameters.

Timeout (Seconds)

Specify how many seconds to wait before throwing an exception.

Required

Output Affected Row Count Variable (Optional)

Create a new variable or select a variable from the list.

Private (Optional)

Optional field to mark the command as private (data sensitive) in order to avoid its logging.

Remote (Optional)

Optional field to mark the command as remote in order to execute it on a remote machine.

Error Handling

Optional field for how to handle errors encountered.

Required

Comment (Optional)

Optional field to enter a custom comment which could potentially describe this command or the need for this command.

Logo